
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EBAS_LICENS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EBAS_LICENS]
GO

CREATE TABLE [dbo].[EBAS_LICENS] (
	[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL ,
	[LICENS_TIL] [varchar] (255) COLLATE Danish_Norwegian_CI_AS NULL ,
	[LICENS_NUMMER] [varchar] (255) COLLATE Danish_Norwegian_CI_AS NULL ,
	[LICENS_TYPE] [varchar] (255) COLLATE Danish_Norwegian_CI_AS NULL ,
	[SLUT_DATO] [datetime] NULL ,
	[VERIFIKATION] [image] NULL ,
	[SALT] [image] NULL 	
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[EBAS_LICENS] WITH NOCHECK ADD 
	CONSTRAINT [PK_EBAS_LICENS] PRIMARY KEY  CLUSTERED 
	(
		[GUID]
	)  ON [PRIMARY] 
GO

INSERT INTO EBAS_LICENS 
	SELECT NEWID(), 'Henley Danmark A/S', '0531-2445-2033-8400', 'STANDARD', '2006-01-01', NULL, NULL
INSERT INTO EBAS_LICENS 
	SELECT NEWID(), 'Henley Danmark A/S', '0328-6936-8101-0788', 'INTERNET', '2006-01-01', NULL, NULL
GO	
